All Questions
Tagged with powershelllist
227 questions
0votes
0answers
20views
Assistance Needed: Extracting Full Modification History from List Items
I need to download the entire history of modifications for the items on my list to identify when the status changed and to obtain those dates for new columns in a table. I am using this code found by ...
0votes
0answers
292views
PnP PowerShell - Update list fields from CSV file
I have the following code and it has been working. Now our company merged and my computer is with the new company domain. New company don't have access to our SharePoint and it seems like it also want ...
0votes
0answers
208views
Import and overwrite SharePoint list with Powershell
I'm using Export-SPWeb to export list from one Sharepoint site collection and Import-SPWeb to import this list to another site collection. I need to do it regularly and that the list and all data in ...
1vote
1answer
168views
Add-PnPView group by secondary field
I have created a script to create number of views in SharePoint, but I am unable to work out the CAML to group by more than one field if it's possible. 1 field being: <GroupBy Collapse="TRUE&...
0votes
1answer
342views
How can I quickly Delete the contents of a SharePoint List View
I've got a SharePoint with a view called Retention that has around half a million entries, I want to delete the entries in the view from SharePoint as they are no longer required but I've not been ...
0votes
2answers
322views
Delete a managed metadata site column from a library only
In SPO, i am trying to delete a Managed Metadata Site Column from a library. I'm using the below script to delete: $SiteURL = "https://Abc.sharepoint.com/sites/SiteName" $ListName = "...
0votes
1answer
70views
How to add multiple read-only columns to Sharepoint List
I am creating a Sharepoint List in Sharepoint Online. I am uploading from an excel file and I want all the columns to be read-only except for something like 'Status' or 'Notes.' When I upload from ...
0votes
1answer
310views
Unable to read Sharepoint List
I setup new Sharepoint list, customized the form using Power App and able to view it and add new data. Now trying to setup a connection to this list to extract items that were added and unable to see ...
0votes
1answer
378views
Read items attachments and write them to local folder
I have this on-premises power shell script which reads SharePoint list attachments and save them to local folder: $ItemAttachmentURLPrefix =$HeaderListItem.Attachments.UrlPrefix $...
0votes
1answer
930views
PNP Powershell Updating Choice field
I have written a powershell script which reads off of a CSV and creates records in a list. There are duplicate customer names within the CSV but they will have a different 'interested system' field. ...
0votes
1answer
378views
Get data from SharePoint List and SQL Table - compare them - PowerShell
I want to make a script which will get data from SharePoint list (from a specific column) and also get data from SQL table (from a specific column) and compare them. If the comparison value is true ...
0votes
1answer
107views
How do you find where an SharePoint auto notification came from?
My issue is trying to locate where an auto notification is coming from that was sent out but ran out of ideas on other ways to try. So I have a couple users that received an auto notification from ...
0votes
1answer
177views
How to delete the last 20 rows of a Sharepoint list with Powershell?
Is it possible to delete the last 20 rows of a sharepoint list with a powershell script? I use the module pnppowershell. Gr. P
0votes
1answer
101views
Change value of PesonOrGroup 'Show field' value with powershell
Using SharePoint 2013 enterprise on-premises. Last week a user recommended changing the 'show field' value from the default to 'Account' on our task lists. This is hundreds of changes as we have 220+ ...
0votes
1answer
105views
Looking for the property name used to toggle to show user picture in SharePoint list field settings
For a given SharePoint list column of type User there's a column setting, a toggle that allows to show the user profile pictures instead of names only. I was looking to toggle this via PowerShell but ...